​
Overview

Dune and its community are building a collection of curated data tables that make it easier to query and analyze blockchain data. These tables are built using dbt, a tool that allows you to transform data in your warehouse using SQL and Jinja templating. We sometimes refer to these tables as spells and the collection of them as spellbook. The curated data tables are built on top of raw data tables and provide a high-level view of the data across multiple blockchain networks. For example, the dex.trades table aggregates data from multiple sources to provide a comprehensive view of all trades on decentralized exchanges across EVM networks, while dex_solana.trades provides similar coverage for Solana DEXs. The curated data tables are maintained in the Spellbook repository and are available for anyone to use.

​
Available Categories

Our curated data is organized by use case to make it easier to find the data you need:

DEX Trades

Comprehensive DEX trading data across EVM and Solana networks

NFT Trades

NFT trading, minting, and metadata across multiple blockchains

Token Transfers

Token transfers, balances, and metadata across EVM and Solana

Address Labels

Identify and categorize blockchain addresses

Token Prices

Historical and real-time token pricing data

​
Cross-Chain Coverage

Our curated data covers multiple blockchain ecosystems:
  • EVM Networks: Ethereum, Arbitrum, Polygon, Base, Optimism, and 40+ other EVM chains
  • Solana: Comprehensive coverage of Solana DeFi and NFT ecosystems
Here is a non-exhaustive list of some of the curated data tables available in Spellbook:

​
Benefits of curated data Tables

Curated data tables provide several benefits:
  • Simplified Queries: curated data tables make it easier to query and analyze blockchain data by providing a high-level view of the data.
  • Cross-Chain Analysis: Consistent data models enable easy comparison between different blockchain networks.
  • Consistent Data Models: The curated data tables follow a consistent data model, making it easier to combine data from different sources.
  • Community Contributions: The curated data tables are maintained by the Dune community, so anyone can contribute to them and improve the data quality.

​
Resources

Spellbook Repo

Go to the dbt github repo with over 400+ contributors. All models live here.

Model Docs

Find the native dbt documentation for all models in spellbook.

dbt practices in Spellbook

Docs for contributing to spellbook and dbt best practices.

Adding to Sector Models

Learn to contribute to sector models like dex.trades and nft.trades tables

Adding a token to prices

Learn to add a token to our prices.usd tracking in a PR